package com.dadonas.fluxocaixa.db;

public abstract class DbConstEntrada {

	public static final String TABLE_NAME = "entradas";
	public static final String COL_ID = "_id";
	public static final String COL_NOME = "nome";
	public static final String COL_PREVISTO = "previsto";
	public static final String COL_REALIZADO = "realizado";
	public static final String COL_DATA = "data";
	public static final String COL_DESCRICAO = "descricao";
	
	public static final String[] COLS = new String[]{
		COL_ID,
		COL_NOME,
		COL_PREVISTO,
		COL_REALIZADO,
		COL_DATA,
		COL_DESCRICAO
	};
	
	public static final String CREATE_TABLE = 
			"  create table " + TABLE_NAME + " ("
			+ COL_ID + " integer primary key autoincrement, "
			+ COL_NOME + " text not null, "
			+ COL_PREVISTO + " real not null, "
			+ COL_REALIZADO + " real, "
			+ COL_DATA + " text not null, "
			+ COL_DESCRICAO + " text); ";
	
}
